package com.czc.cca.ddl;

import org.zoomdev.zoom.dao.ddl.*;
import org.zoomdev.zoom.dao.driver.mysql.MysqlDriver;

@_DDL_Table(name = "t_rec", simpleName = "", engine = MysqlDriver.InnoDB, comment = "交易记录,会导致用户账户余额变化")
public class _DDL_Rec {

    @_DDL_Primary()
    @_DDL_Column(name = "id", type = SqlType.BIGINT_UNSIGNED, nullable = false, comment = "原交易id")
    private java.math.BigInteger id;

    @_DDL_Column(name = "amt", type = SqlType.DECIMAL, size = 8, scale = 2, nullable = false, comment = "交易金额(元）")
    private java.math.BigDecimal amt;

    @_DDL_Index(name = "IDX_t_rec_usr_id")
    @_DDL_Column(name = "usr_id", type = SqlType.INT_UNSIGNED, comment = "用户id")
    private Long usrId;

    @_DDL_Column(name = "type", type = SqlType.TINYINT_UNSIGNED, comment = "类型 0:pay 2:recharge 3 withdraw 4 refund")
    private Integer type;

    @_DDL_Column(name = "mer_id", type = SqlType.BIGINT_UNSIGNED, comment = "商户id")
    private java.math.BigInteger merId;

}
